




/*
'===============================================================================
'  HNG.Portal.BL.TblWebInfoManagerBase
'===============================================================================
*/

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using HNG.Portal.BLL;
using HNG.Portal.DAL;
using HNG.Portal.DAL.EntityClasses;
using HNG.Portal.DAL.FactoryClasses;
using HNG.Portal.DAL.HelperClasses;
using SD.LLBLGen.Pro.ORMSupportClasses;
using System.Windows.Forms;
namespace HNG.Portal.BLL
{
	public class TblWebInfoManagerBase
	{
	    
		#region ColumnNames
		
				public const String Field_Id="Id";
				
				public const String Field_WebName="WebName";
				
				public const String Field_WebTitle="WebTitle";
				
				public const String Field_Keywords="Keywords";
				
				public const String Field_Description="Description";
				
				public const String Field_LogoPath="LogoPath";
				
				public const String Field_LogoLink="LogoLink";
				
				public const String Field_BannerPath="BannerPath";
				
				public const String Field_BannerLink="BannerLink";
				
				public const String Field_Intro="Intro";
				
				public const String Field_SupportText="SupportText";
				
				public const String Field_Policy="Policy";
				
				public const String Field_ContactInfo="ContactInfo";
				
				public const String Field_Footer="Footer";
				
				public const String Field_CreateDate="CreateDate";
				
				public const String Field_UpdateDate="UpdateDate";
				
				public const String Field_Used="Used";
				
				public const String Field_LangId="LangId";
				
		#endregion	
		/// <summary>
		/// Purpose: Class constructor.
		/// </summary>
		public TblWebInfoManagerBase()
		{
			// Nothing for now.
		}
		public DataTable Clone()
		{
			DataTable dt = new DataTable();
						
			
			dt.Columns.Add(Field_Id,typeof(int));
			
						
			
			dt.Columns.Add(Field_WebName,typeof(string));
			
						
			
			dt.Columns.Add(Field_WebTitle,typeof(string));
			
						
			
			dt.Columns.Add(Field_Keywords,typeof(string));
			
						
			
			dt.Columns.Add(Field_Description,typeof(string));
			
						
			
			dt.Columns.Add(Field_LogoPath,typeof(string));
			
						
			
			dt.Columns.Add(Field_LogoLink,typeof(string));
			
						
			
			dt.Columns.Add(Field_BannerPath,typeof(string));
			
						
			
			dt.Columns.Add(Field_BannerLink,typeof(string));
			
						
			
			dt.Columns.Add(Field_Intro,typeof(string));
			
						
			
			dt.Columns.Add(Field_SupportText,typeof(string));
			
						
			
			dt.Columns.Add(Field_Policy,typeof(string));
			
						
			
			dt.Columns.Add(Field_ContactInfo,typeof(string));
			
						
			
			dt.Columns.Add(Field_Footer,typeof(string));
			
						
			
			dt.Columns.Add(Field_CreateDate,typeof(DateTime));
			
						
			
			dt.Columns.Add(Field_UpdateDate,typeof(DateTime));
			
						
			
			dt.Columns.Add(Field_Used,typeof(bool));
			
						
			
			dt.Columns.Add(Field_LangId,typeof(string));
			
			            
            return dt;			
		}
			
		public TblWebInfoEntity Convert_Entity(TblWebInfoEntity _TblWebInfoEntity,TblWebInfoEntity _TblWebInfoEntity_XML)
		{	
			
				
			_TblWebInfoEntity.Id= _TblWebInfoEntity_XML.Id;
				
			_TblWebInfoEntity.WebName= _TblWebInfoEntity_XML.WebName;
				
			_TblWebInfoEntity.WebTitle= _TblWebInfoEntity_XML.WebTitle;
				
			_TblWebInfoEntity.Keywords= _TblWebInfoEntity_XML.Keywords;
				
			_TblWebInfoEntity.Description= _TblWebInfoEntity_XML.Description;
				
			_TblWebInfoEntity.LogoPath= _TblWebInfoEntity_XML.LogoPath;
				
			_TblWebInfoEntity.LogoLink= _TblWebInfoEntity_XML.LogoLink;
				
			_TblWebInfoEntity.BannerPath= _TblWebInfoEntity_XML.BannerPath;
				
			_TblWebInfoEntity.BannerLink= _TblWebInfoEntity_XML.BannerLink;
				
			_TblWebInfoEntity.Intro= _TblWebInfoEntity_XML.Intro;
				
			_TblWebInfoEntity.SupportText= _TblWebInfoEntity_XML.SupportText;
				
			_TblWebInfoEntity.Policy= _TblWebInfoEntity_XML.Policy;
				
			_TblWebInfoEntity.ContactInfo= _TblWebInfoEntity_XML.ContactInfo;
				
			_TblWebInfoEntity.Footer= _TblWebInfoEntity_XML.Footer;
				
			_TblWebInfoEntity.CreateDate= _TblWebInfoEntity_XML.CreateDate;
				
			_TblWebInfoEntity.UpdateDate= _TblWebInfoEntity_XML.UpdateDate;
				
			_TblWebInfoEntity.Used= _TblWebInfoEntity_XML.Used;
				
			_TblWebInfoEntity.LangId= _TblWebInfoEntity_XML.LangId;
				
			
			return _TblWebInfoEntity;
		}	
		
			
		public void InsertCollection(EntityCollection _Collection)
		{
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
            {
                adapter.SaveEntityCollection(_Collection);
            }
		}

		public TblWebInfoEntity Insert(TblWebInfoEntity TblWebInfoEntity)
		{
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.SaveEntity(TblWebInfoEntity, true);
			}
			return TblWebInfoEntity;
		}

		
		public TblWebInfoEntity Insert(int Id, string WebName, string WebTitle, string Keywords, string Description, string LogoPath, string LogoLink, string BannerPath, string BannerLink, string Intro, string SupportText, string Policy, string ContactInfo, string Footer, DateTime CreateDate, DateTime UpdateDate, bool Used, string LangId)
		{
			TblWebInfoEntity _TblWebInfoEntity = new TblWebInfoEntity();
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				
				_TblWebInfoEntity.Id = Id;
				_TblWebInfoEntity.WebName = WebName;
				_TblWebInfoEntity.WebTitle = WebTitle;
				_TblWebInfoEntity.Keywords = Keywords;
				_TblWebInfoEntity.Description = Description;
				_TblWebInfoEntity.LogoPath = LogoPath;
				_TblWebInfoEntity.LogoLink = LogoLink;
				_TblWebInfoEntity.BannerPath = BannerPath;
				_TblWebInfoEntity.BannerLink = BannerLink;
				_TblWebInfoEntity.Intro = Intro;
				_TblWebInfoEntity.SupportText = SupportText;
				_TblWebInfoEntity.Policy = Policy;
				_TblWebInfoEntity.ContactInfo = ContactInfo;
				_TblWebInfoEntity.Footer = Footer;
				_TblWebInfoEntity.CreateDate = CreateDate;
				_TblWebInfoEntity.UpdateDate = UpdateDate;
				_TblWebInfoEntity.Used = Used;
				_TblWebInfoEntity.LangId = LangId;
				adapter.SaveEntity(_TblWebInfoEntity, true);
			}
			return _TblWebInfoEntity;
		}

		public TblWebInfoEntity Insert(string WebName, string WebTitle, string Keywords, string Description, string LogoPath, string LogoLink, string BannerPath, string BannerLink, string Intro, string SupportText, string Policy, string ContactInfo, string Footer, DateTime CreateDate, DateTime UpdateDate, bool Used, string LangId)
		{
			TblWebInfoEntity _TblWebInfoEntity = new TblWebInfoEntity();
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				
				_TblWebInfoEntity.WebName = WebName;
				_TblWebInfoEntity.WebTitle = WebTitle;
				_TblWebInfoEntity.Keywords = Keywords;
				_TblWebInfoEntity.Description = Description;
				_TblWebInfoEntity.LogoPath = LogoPath;
				_TblWebInfoEntity.LogoLink = LogoLink;
				_TblWebInfoEntity.BannerPath = BannerPath;
				_TblWebInfoEntity.BannerLink = BannerLink;
				_TblWebInfoEntity.Intro = Intro;
				_TblWebInfoEntity.SupportText = SupportText;
				_TblWebInfoEntity.Policy = Policy;
				_TblWebInfoEntity.ContactInfo = ContactInfo;
				_TblWebInfoEntity.Footer = Footer;
				_TblWebInfoEntity.CreateDate = CreateDate;
				_TblWebInfoEntity.UpdateDate = UpdateDate;
				_TblWebInfoEntity.Used = Used;
				_TblWebInfoEntity.LangId = LangId;
				adapter.SaveEntity(_TblWebInfoEntity, true);
			}
			return _TblWebInfoEntity;
		}

		public bool Update(TblWebInfoEntity _TblWebInfoEntity)
		{
			bool toReturn = false;
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				RelationPredicateBucket filter = new RelationPredicateBucket();
				IPredicateExpression _PredicateExpression = new PredicateExpression();
				_PredicateExpression.Add(TblWebInfoFields.Id == _TblWebInfoEntity.Id);
					
				filter.PredicateExpression.Add(_PredicateExpression);

				adapter.UpdateEntitiesDirectly(_TblWebInfoEntity, filter);
				toReturn = true;
			}
			return toReturn;
		}
		
		public bool Update(TblWebInfoEntity _TblWebInfoEntity, RelationPredicateBucket filter)
		{
			bool toReturn = false;
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.UpdateEntitiesDirectly(_TblWebInfoEntity, filter);
				toReturn = true;
			}
			return toReturn;
		}

		public bool Update(int Id, string WebName, string WebTitle, string Keywords, string Description, string LogoPath, string LogoLink, string BannerPath, string BannerLink, string Intro, string SupportText, string Policy, string ContactInfo, string Footer, DateTime CreateDate, DateTime UpdateDate, bool Used, string LangId)
		{
			bool toReturn = false;
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				TblWebInfoEntity _TblWebInfoEntity = new TblWebInfoEntity(Id);
				if (adapter.FetchEntity(_TblWebInfoEntity))
				{
				
					_TblWebInfoEntity.WebName = WebName;
					_TblWebInfoEntity.WebTitle = WebTitle;
					_TblWebInfoEntity.Keywords = Keywords;
					_TblWebInfoEntity.Description = Description;
					_TblWebInfoEntity.LogoPath = LogoPath;
					_TblWebInfoEntity.LogoLink = LogoLink;
					_TblWebInfoEntity.BannerPath = BannerPath;
					_TblWebInfoEntity.BannerLink = BannerLink;
					_TblWebInfoEntity.Intro = Intro;
					_TblWebInfoEntity.SupportText = SupportText;
					_TblWebInfoEntity.Policy = Policy;
					_TblWebInfoEntity.ContactInfo = ContactInfo;
					_TblWebInfoEntity.Footer = Footer;
					_TblWebInfoEntity.CreateDate = CreateDate;
					_TblWebInfoEntity.UpdateDate = UpdateDate;
					_TblWebInfoEntity.Used = Used;
					_TblWebInfoEntity.LangId = LangId;
					adapter.SaveEntity(_TblWebInfoEntity, true);
					toReturn = true;
				}
			}
			return toReturn;
		}

		public bool Delete(int Id)
		{
			bool toReturn = false;
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				TblWebInfoEntity _TblWebInfoEntity = new TblWebInfoEntity(Id);
				if (adapter.FetchEntity(_TblWebInfoEntity))
				{
					adapter.DeleteEntity(_TblWebInfoEntity);
					toReturn = true;
				}
			}
			return toReturn;
		}
		
		public void DeleteAll() 
		{
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.DeleteEntitiesDirectly("TblWebInfoEntity", null);
			}
		}
		
		
		public int DeleteById(int Id)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Id == Id);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByWebName(string WebName)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.WebName == WebName);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByWebTitle(string WebTitle)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.WebTitle == WebTitle);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByKeywords(string Keywords)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Keywords == Keywords);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByDescription(string Description)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Description == Description);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByLogoPath(string LogoPath)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LogoPath == LogoPath);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByLogoLink(string LogoLink)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LogoLink == LogoLink);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByBannerPath(string BannerPath)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.BannerPath == BannerPath);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByBannerLink(string BannerLink)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.BannerLink == BannerLink);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByIntro(string Intro)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Intro == Intro);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteBySupportText(string SupportText)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.SupportText == SupportText);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByPolicy(string Policy)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Policy == Policy);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByContactInfo(string ContactInfo)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.ContactInfo == ContactInfo);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByFooter(string Footer)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Footer == Footer);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByCreateDate(DateTime CreateDate)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.CreateDate == CreateDate);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByUpdateDate(DateTime UpdateDate)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.UpdateDate == UpdateDate);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByUsed(bool Used)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Used == Used);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		
		public int DeleteByLangId(string LangId)
		{
			int toReturn = 0;
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LangId == LangId);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				toReturn = adapter.DeleteEntitiesDirectly("TblWebInfoEntity", filter);
			}
			return toReturn;
		}
		

		
		public TblWebInfoEntity SelectOne(int Id)
		{
			TblWebInfoEntity toReturn = null;
			using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				TblWebInfoEntity _TblWebInfoEntity = new TblWebInfoEntity(Id);
				if (adapter.FetchEntity(_TblWebInfoEntity))
				{
					toReturn = _TblWebInfoEntity;
				}
			}
			return toReturn;
		}

		// Return EntityCollection
		public EntityCollection SelectAll()
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection( new TblWebInfoEntityFactory());
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, null, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectAllRDT()
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, null, true);
			}
			return toReturn;
		}

		
		// Return EntityCollection
		public EntityCollection SelectById(int Id)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Id == Id);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByIdRDT(int Id)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Id == Id);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByWebName(string WebName)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.WebName == WebName);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByWebNameRDT(string WebName)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.WebName == WebName);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByWebTitle(string WebTitle)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.WebTitle == WebTitle);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByWebTitleRDT(string WebTitle)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.WebTitle == WebTitle);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByKeywords(string Keywords)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Keywords == Keywords);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByKeywordsRDT(string Keywords)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Keywords == Keywords);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByDescription(string Description)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Description == Description);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByDescriptionRDT(string Description)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Description == Description);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByLogoPath(string LogoPath)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LogoPath == LogoPath);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByLogoPathRDT(string LogoPath)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LogoPath == LogoPath);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByLogoLink(string LogoLink)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LogoLink == LogoLink);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByLogoLinkRDT(string LogoLink)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LogoLink == LogoLink);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByBannerPath(string BannerPath)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.BannerPath == BannerPath);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByBannerPathRDT(string BannerPath)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.BannerPath == BannerPath);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByBannerLink(string BannerLink)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.BannerLink == BannerLink);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByBannerLinkRDT(string BannerLink)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.BannerLink == BannerLink);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByIntro(string Intro)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Intro == Intro);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByIntroRDT(string Intro)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Intro == Intro);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectBySupportText(string SupportText)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.SupportText == SupportText);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectBySupportTextRDT(string SupportText)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.SupportText == SupportText);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByPolicy(string Policy)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Policy == Policy);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByPolicyRDT(string Policy)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Policy == Policy);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByContactInfo(string ContactInfo)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.ContactInfo == ContactInfo);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByContactInfoRDT(string ContactInfo)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.ContactInfo == ContactInfo);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByFooter(string Footer)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Footer == Footer);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByFooterRDT(string Footer)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Footer == Footer);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByCreateDate(DateTime CreateDate)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.CreateDate == CreateDate);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByCreateDateRDT(DateTime CreateDate)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.CreateDate == CreateDate);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByUpdateDate(DateTime UpdateDate)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.UpdateDate == UpdateDate);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByUpdateDateRDT(DateTime UpdateDate)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.UpdateDate == UpdateDate);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByUsed(bool Used)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Used == Used);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByUsedRDT(bool Used)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.Used == Used);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		// Return EntityCollection
		public EntityCollection SelectByLangId(string LangId)
		{
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();

			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LangId == LangId);
			filter.PredicateExpression.Add(_PredicateExpression);
			
			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchEntityCollection(_TblWebInfoCollection, filter, 0, null);
			}
			return _TblWebInfoCollection;
		}
		
		// Return DataTable
		public DataTable SelectByLangIdRDT(string LangId)
		{
			DataTable toReturn = new DataTable();
			EntityCollection _TblWebInfoCollection = new EntityCollection(new TblWebInfoEntityFactory());
			RelationPredicateBucket filter = new RelationPredicateBucket();
			
			IPredicateExpression _PredicateExpression = new PredicateExpression();
			_PredicateExpression.Add(TblWebInfoFields.LangId == LangId);
			filter.PredicateExpression.Add(_PredicateExpression);

			using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
			{
				adapter.FetchTypedList(_TblWebInfoCollection.EntityFactoryToUse.CreateFields(), toReturn, filter, true);
			}
			return toReturn;
		}
		
		

	}
}
